{
 "cells": [
  {
   "cell_type": "code",
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2025-03-19T07:17:06.362034Z",
     "start_time": "2025-03-19T07:17:05.729812Z"
    }
   },
   "source": "import pandas as pd",
   "outputs": [],
   "execution_count": 1
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2025-03-19T07:17:32.120725Z",
     "start_time": "2025-03-19T07:17:30.396352Z"
    }
   },
   "cell_type": "code",
   "source": [
    "df = pd.read_csv('data/dataPerformance.csv')\n",
    "df"
   ],
   "id": "c76e01d43e939584",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "           vol        low       high      close       open       vwap  \\\n",
       "0        95672  38.641675  39.595867  37.720254  39.106031  37.720254   \n",
       "1        55384  10.877345  12.662179  12.581137  11.940472  12.581137   \n",
       "2        13176  48.487343  50.215164  51.122646  49.341137  51.122646   \n",
       "3        48186  49.599668  49.950416  50.922727  49.610556  50.922727   \n",
       "4         1503  18.299138  20.048211  18.424623  19.159891  18.424623   \n",
       "...        ...        ...        ...        ...        ...        ...   \n",
       "1043995  47031   1.021425   1.764663   2.088905   0.792817   2.088905   \n",
       "1043996  96768  57.603940  58.510277  58.320727  58.003060  58.320727   \n",
       "1043997  23666  48.246643  49.569553  44.179468  49.011854  44.179468   \n",
       "1043998  83976  57.072339  57.142240  54.839751  57.123190  54.839751   \n",
       "1043999  40088  15.904059  16.894453  17.312625  16.456826  17.312625   \n",
       "\n",
       "                       tradetime securityid  indclass           cap  \n",
       "0        2010.01.01T00:00:00.000   sz000001  40352080  8.544707e+08  \n",
       "1        2010.01.04T00:00:00.000   sz000001  40352080  8.544707e+08  \n",
       "2        2010.01.05T00:00:00.000   sz000001  40352080  8.544707e+08  \n",
       "3        2010.01.06T00:00:00.000   sz000001  40352080  8.544707e+08  \n",
       "4        2010.01.07T00:00:00.000   sz000001  40352080  8.544707e+08  \n",
       "...                          ...        ...       ...           ...  \n",
       "1043995  2010.12.27T00:00:00.000   sz004000  40151070  3.840934e+08  \n",
       "1043996  2010.12.28T00:00:00.000   sz004000  40151070  3.840934e+08  \n",
       "1043997  2010.12.29T00:00:00.000   sz004000  40151070  3.840934e+08  \n",
       "1043998  2010.12.30T00:00:00.000   sz004000  40151070  3.840934e+08  \n",
       "1043999  2010.12.31T00:00:00.000   sz004000  40151070  3.840934e+08  \n",
       "\n",
       "[1044000 rows x 10 columns]"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vol</th>\n",
       "      <th>low</th>\n",
       "      <th>high</th>\n",
       "      <th>close</th>\n",
       "      <th>open</th>\n",
       "      <th>vwap</th>\n",
       "      <th>tradetime</th>\n",
       "      <th>securityid</th>\n",
       "      <th>indclass</th>\n",
       "      <th>cap</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>95672</td>\n",
       "      <td>38.641675</td>\n",
       "      <td>39.595867</td>\n",
       "      <td>37.720254</td>\n",
       "      <td>39.106031</td>\n",
       "      <td>37.720254</td>\n",
       "      <td>2010.01.01T00:00:00.000</td>\n",
       "      <td>sz000001</td>\n",
       "      <td>40352080</td>\n",
       "      <td>8.544707e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>55384</td>\n",
       "      <td>10.877345</td>\n",
       "      <td>12.662179</td>\n",
       "      <td>12.581137</td>\n",
       "      <td>11.940472</td>\n",
       "      <td>12.581137</td>\n",
       "      <td>2010.01.04T00:00:00.000</td>\n",
       "      <td>sz000001</td>\n",
       "      <td>40352080</td>\n",
       "      <td>8.544707e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>13176</td>\n",
       "      <td>48.487343</td>\n",
       "      <td>50.215164</td>\n",
       "      <td>51.122646</td>\n",
       "      <td>49.341137</td>\n",
       "      <td>51.122646</td>\n",
       "      <td>2010.01.05T00:00:00.000</td>\n",
       "      <td>sz000001</td>\n",
       "      <td>40352080</td>\n",
       "      <td>8.544707e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48186</td>\n",
       "      <td>49.599668</td>\n",
       "      <td>49.950416</td>\n",
       "      <td>50.922727</td>\n",
       "      <td>49.610556</td>\n",
       "      <td>50.922727</td>\n",
       "      <td>2010.01.06T00:00:00.000</td>\n",
       "      <td>sz000001</td>\n",
       "      <td>40352080</td>\n",
       "      <td>8.544707e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1503</td>\n",
       "      <td>18.299138</td>\n",
       "      <td>20.048211</td>\n",
       "      <td>18.424623</td>\n",
       "      <td>19.159891</td>\n",
       "      <td>18.424623</td>\n",
       "      <td>2010.01.07T00:00:00.000</td>\n",
       "      <td>sz000001</td>\n",
       "      <td>40352080</td>\n",
       "      <td>8.544707e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043995</th>\n",
       "      <td>47031</td>\n",
       "      <td>1.021425</td>\n",
       "      <td>1.764663</td>\n",
       "      <td>2.088905</td>\n",
       "      <td>0.792817</td>\n",
       "      <td>2.088905</td>\n",
       "      <td>2010.12.27T00:00:00.000</td>\n",
       "      <td>sz004000</td>\n",
       "      <td>40151070</td>\n",
       "      <td>3.840934e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043996</th>\n",
       "      <td>96768</td>\n",
       "      <td>57.603940</td>\n",
       "      <td>58.510277</td>\n",
       "      <td>58.320727</td>\n",
       "      <td>58.003060</td>\n",
       "      <td>58.320727</td>\n",
       "      <td>2010.12.28T00:00:00.000</td>\n",
       "      <td>sz004000</td>\n",
       "      <td>40151070</td>\n",
       "      <td>3.840934e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043997</th>\n",
       "      <td>23666</td>\n",
       "      <td>48.246643</td>\n",
       "      <td>49.569553</td>\n",
       "      <td>44.179468</td>\n",
       "      <td>49.011854</td>\n",
       "      <td>44.179468</td>\n",
       "      <td>2010.12.29T00:00:00.000</td>\n",
       "      <td>sz004000</td>\n",
       "      <td>40151070</td>\n",
       "      <td>3.840934e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043998</th>\n",
       "      <td>83976</td>\n",
       "      <td>57.072339</td>\n",
       "      <td>57.142240</td>\n",
       "      <td>54.839751</td>\n",
       "      <td>57.123190</td>\n",
       "      <td>54.839751</td>\n",
       "      <td>2010.12.30T00:00:00.000</td>\n",
       "      <td>sz004000</td>\n",
       "      <td>40151070</td>\n",
       "      <td>3.840934e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043999</th>\n",
       "      <td>40088</td>\n",
       "      <td>15.904059</td>\n",
       "      <td>16.894453</td>\n",
       "      <td>17.312625</td>\n",
       "      <td>16.456826</td>\n",
       "      <td>17.312625</td>\n",
       "      <td>2010.12.31T00:00:00.000</td>\n",
       "      <td>sz004000</td>\n",
       "      <td>40151070</td>\n",
       "      <td>3.840934e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1044000 rows × 10 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 2
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2025-03-19T07:19:07.434446Z",
     "start_time": "2025-03-19T07:19:06.576784Z"
    }
   },
   "cell_type": "code",
   "source": "df.to_parquet(\"data/dataPerformance.parquet\")",
   "id": "8b5ca5a0681750a0",
   "outputs": [],
   "execution_count": 3
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
